package com.xinsoft.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xinsoft.entity.dto.SysLevelPriceRefDTO;
import com.xinsoft.entity.dto.SysLevelPriceRefParam;
import com.xinsoft.entity.po.SysLevelPriceRef;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.Map;

/**
 * @author ZYM
 * @description 针对表【sys_level_price_ref(等级价格)】的数据库操作Mapper
 * @createDate 2023-07-25 13:23:50
 * @Entity com.xinsoft.entity.po.SysLevelPriceRef
 */
public interface SysLevelPriceRefMapper extends BaseMapper<SysLevelPriceRef> {

    IPage<Map<String, Object>> findPageListByParam(Page<Map<String, Object>> page, SysLevelPriceRefParam param, String sqlFragment);


    int batchUpdatePrice(SysLevelPriceRefDTO sysLevelPriceRefDTOf);
    int batchUpdatePrice1(SysLevelPriceRefDTO sysLevelPriceRefDTOf);

    /**
     * 获取SQL片段
     * @return {@link String} SQL片段
     */
    String getSqlFragment();

}




